Right Anti Semi Join
Short Description
The right Anti Semi Join operator returns rows from the second input where it has no match in the first input.
Detailed Description​
The right Anti Semi Join operator returns rows from the second input where it has no match in the first input. This can be used to check for orphaned child records using a NOT EXISTS type query.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.